1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12 <meta charset="utf-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1.0">
14 <title>school management system</title>
15 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
17 <link href="assets/css/loader.css" rel="stylesheet" />
18 <script src="assets/js/canvasjs.min.js"></script>
19 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
20 <script src="assets/js/jquery-3.2.1.js"></script>
21 </head>
22
23 <body >
24 <!--end of heading section-->
25 <ul class="nav navbar-right top-nav">
26 <div class="dropdown">
27 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
28 <?php
29 //Check to see if the user is logged in.if not redirect user to the loging page.
30
31 if(isset($_SESSION['fname']))
32 {
33 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
34 }else{
35 echo "<script type='text/javascript'>
36 alert( 'You must Log in to use the system');
37 </script>";
38 echo "<script>
39 window.location = 'index.php'
40 </script>";
41 }
42 ?>
43 <span class="caret"></span></button>
44 <ul class="dropdown-menu">
45 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
46 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
47 <li class="divider"></li>
48 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
49 </ul>
50 </div>
51 </ul>
52 <!--************************************************-->
53 <div style="
54 font-family:Nyala, Arial;
55 text-align: left;
56 background-color: #526F35;
57 padding: 20px;
58 color:white;
59 width: 100%;
60 height: 150px;">
61 <!--This codes to load the image loader-->
62 <div id="loading">
63 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
64 </div>
65 <!--this is the heading section-->
66 <h2>
67 <?php
68 $sql="SELECT * FROM companyinfo";
69 $result=mysqli_query($db,$sql) or die("error getting data");
70 $num_rows=mysqli_num_rows($result);
71 while($row=mysqli_fetch_array($result))
72 {
73 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
74 $cname = $row['cname'];
75 $cemail = $row['cemail'];
76 $ccontact = $row['ccontact'];
77 $clocation = $row['clocation'];
78 }?>
79 <?php
80 echo $cname;
81 ?>
82
83 <div style="float:right; font-size:20px;text-align:right;">
84
85 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
86 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
87 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
88
89 </div>
90 </h2>
91 </div>
92 <!--end of heading section-->
93 <div>
94 <ul class="nav nav-tabs">
95 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
96 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
97 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
98 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
99 <li ><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
100 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
101 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
102 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
103 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
104 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
105
106 </ul>
107 <div class="tab-content">
108 <div class="tab-pane active" role="tabpanel" id="tab-1">
109
110 <p>
111 <div class="table-responsive" >
112 <!--****************************************************************************-->
113 <div class="container" style="width:100%">
114
115 <ul class="nav nav-tabs">
116 <li ><a href="m1.php">Record New Case <img src="assets/img/new.png"> </a></li>
117 <li class="active"><a href="m2.php">History<img src="assets/img/update2.png"> </a></li>
118 </ul>
119 <br>
120
121 </div>
122
123 <!--*************************************************************************************************************************-->
124 <div class="container-fluid">
125 <div class="row">
126
127 <div class="panel panel-primary">
128 <div class="panel-heading">Student ID <?php echo $_GET['admission_number']; ?> </div>
129
130 <!-- /.panel-heading -->
131 <div class="panel-body">
132 <div class="table">
133
134
135 <form action="xx.php" method="POST" enctype="multipart/form-data">
136
137 <!--****************put the school fee codes here**********-->
138 <label>School fee</label>
139 <div style="height:auto; background-color: #F34721;">
140
141 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
142 <?php
143 $admission_number=$_GET['admission_number'];
144 $sql="SELECT SUM(amount) AS value_sum FROM fee WHERE admission_number='$admission_number'";
145 $user_query=mysqli_query($db,$sql) or die("error getting data");
146 while($row = mysqli_fetch_array($user_query)){
147
148 $totalpaid= $row['value_sum'];
149 }
150 //$balance=$feepayable-$totalpaid;
151
152 ?>
153
154 <thead>
155 <tr>
156 <th></th>
157 <th><center>Reciept #.</center></th>
158 <th><center>Method</center></th>
159 <th><center>Ref #</center></th>
160 <th><center>Date</center></th>
161 <th><center>Amount</center></th>
162
163
164 <script src="assets/js/jquery.dataTables.min.js"></script>
165 <script src="assets/js/DT_bootstrap.js"></script>
166 <th></th>
167 </tr>
168 </thead>
169 <tbody>
170 <?php
171
172 $admission_number=$_GET['admission_number'];
173 $sql ="SELECT * from fee where admission_number='$admission_number'";
174 $user_query=mysqli_query($db,$sql) or die("error getting data");
175 while($row = mysqli_fetch_array($user_query)){
176 $admission_number = $row['admission_number'];
177 ?>
178
179
180 <tr>
181 <td width="30">
182 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $admission_number; ?>">
183 </td>
184 <td><center><?php echo $row['reciept']; ?></center></td>
185 <td><center><?php echo $row['method']; ?></center></td>
186 <td><center><?php echo $row['refno']; ?></center></td>
187 <td><center><?php echo $row['tdate']; ?></center></td>
188 <td><center><?php echo $row['amount']; ?></center></td>
189
190 </tr>
191
192 <?php } ?>
193 <tr style="background-color:#D79778;">
194 <td><center></center></td>
195 <td><center></center></td>
196 <td><center></center></td>
197 <td><center></center></td>
198 <td><center><b><i>Total fee paid<i></b></center></td>
199 <td><center><b><i><?php echo $totalpaid ; ?></i></b></center></td>
200 <td><center></center></td>
201 </tr>
202 </tbody>
203 </table>
204 </form>
205 </div>
206 <!--****************end of the school fee codes here****************-->
207 <!--****************put the academic perfomance codes here**********-->
208
209 <label>Perfomance</label>
210 <div style="height:auto;">
211
212 <form method="post">
213 <div class="table-responsive">
214 <table cellpadding="0" cellspacing="0" border="0" class="table" id="myTable">
215
216 <thead>
217 <tr>
218 <th></th>
219 <th><center>Class/Course ID</center></th>
220
221 <th><center>Term</center></th>
222 <th><center>Year</center></th>
223 <th><center>Mathematics</center></th>
224 <th><center>English</center></th>
225 <th><center>Kiswahili</center></th>
226 <th><center>Science</center></th>
227 <th><center>Social Studies</center></th>
228 <th><center>Total</center></th>
229 <th><center>Average</center></th>
230 <th><center>Grade</center></th>
231
232 <!-- <th><center>Rank</center></th> -->
233 <script src="assets/js/jquery.dataTables.min.js"></script>
234 <script src="assets/js/DT_bootstrap.js"></script>
235 <th></th>
236 </tr>
237 </thead>
238 <tbody>
239 <!--Calculating the totals marks************************************************************************************-->
240 <?php
241 $admission_number=$_GET['admission_number'];
242
243 $sql="SELECT SUM(maths),SUM(english),SUM(kiswahili),SUM(social_studies),SUM(science),SUM(maths + english + kiswahili + social_studies + science) AS totalfinal
244 from marks WHERE admission_number='$admission_number' ";
245 $user_query=mysqli_query($db,$sql);
246 while($row1=mysqli_fetch_array($user_query)){
247 $maths=$row1['SUM(maths)'];
248 $english=$row1['SUM(english)'];
249 $kiswahili=$row1['SUM(kiswahili)'];
250 $social_studies=$row1['SUM(social_studies)'];
251 $science=$row1['SUM(science)'];
252 $totalfinal=$row1['totalfinal'];
253 }?>
254 <!--Calculating the Average marks************************************************************************************-->
255 <?php
256 $admission_number=$_GET['admission_number'];
257
258 $sql="SELECT ROUND(AVG(maths),2),ROUND(AVG(english),2),ROUND(AVG(kiswahili),2),ROUND(AVG(social_studies),2),ROUND(AVG(science),2), ROUND(AVG(maths + english + kiswahili + social_studies + science)) AS Averagefinal
259 from marks WHERE admission_number='$admission_number' ";
260 $user_query=mysqli_query($db,$sql);
261 while($row1=mysqli_fetch_array($user_query)){
262 $amaths=$row1['ROUND(AVG(maths),2)'];
263 $aenglish=$row1['ROUND(AVG(english),2)'];
264 $akiswahili=$row1['ROUND(AVG(kiswahili),2)'];
265 $asocial_studies=$row1['ROUND(AVG(social_studies),2)'];
266 $ascience=$row1['ROUND(AVG(science),2)'];
267 $Averagefinal=$row1['Averagefinal'];
268 $classaverage=($amaths +$aenglish + $akiswahili +$asocial_studies +$ascience)/5;
269
270 }?>
271 <!--Looking for final class grade and assingn it variable $classgrade*************************************************-->
272 <?php
273 if ($classaverage > "80") {
274 $classgrade="A";
275 }
276 elseif (($classaverage > "60") && ($classaverage < "80"))
277 {
278 $classgrade="B";
279 }
280 elseif (($classaverage > "40") && ($classaverage < "60"))
281 {
282 $classgrade="C";
283 }
284 elseif (($classaverage > "0") && ($classaverage < "40"))
285 {
286 $classgrade="F";
287 }
288 else{
289 $classgrade="";
290 }
291
292 ?>
293 <!--Displaying the data************************************************************************************-->
294 <?php
295 $admission_number=$_GET['admission_number'];
296
297 $sql ="SELECT course_id,admission_number,term,year,maths,english,kiswahili,social_studies,science, average,
298 ( maths + english + kiswahili + social_studies + science)AS total2,
299 CASE
300 WHEN ((maths + english + kiswahili + social_studies + science )/(100*5) * 100) >= 80 THEN 'A'
301 WHEN ((maths + english + kiswahili + social_studies + science )/(100*5) * 100) >=60 THEN 'B'
302 WHEN ((maths + english + kiswahili + social_studies + science )/(100*5) * 100) >=40 THEN 'C'
303 ELSE 'FAIL'
304 END AS grade,
305
306 FIND_IN_SET ( average, (SELECT GROUP_CONCAT( average ORDER BY average DESC )FROM marks ))
307 AS rank
308
309 from marks where admission_number='$admission_number' ORDER BY course_id ASC";
310 $user_query=mysqli_query($db,$sql) or die("error getting data");
311 while($row = mysqli_fetch_array($user_query)){
312 $id = $row['admission_number'];
313
314 ?>
315 <tr>
316 <td width="30">
317 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $id; ?>">
318
319 </td>
320
321 <td><center><?php echo $row['course_id']; ?></center></td>
322 <td><center><?php echo $row['term']; ?></center></td>
323 <td><center><?php echo $row['year']; ?></center></td>
324 <td><center><?php echo $row['maths']; ?></center></td>
325 <td><center><?php echo $row['english']; ?></center></td>
326 <td><center><?php echo $row['kiswahili']; ?></center></td>
327 <td><center><?php echo $row['social_studies']; ?></center></td>
328 <td><center><?php echo $row['science']; ?></center></td>
329 <td><center><?php echo $row['total2']; ?></center></td>
330 <td><center><?php echo $row['average']; ?></center></td>
331 <td><center><?php echo $row['grade']; ?></center></td>
332
333 <!-- <td><center> //<?php //echo $row['rank']; ?><!-- </center></td> -->
334
335 </tr>
336 <!--end of Displaying the data************************************************************************************-->
337 <?php } ?>
338
339 <tr >
340 <td width="30">
341 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" >
342 </td>
343 <th><center>Total</th>
344 <th><center>-</th>
345 <th><center>-</th>
346 <th><center><?php echo $maths ?></center></th>
347 <th><center><?php echo $english ?></center></th>
348 <th><center><?php echo $kiswahili ?></center></th>
349 <th><center><?php echo $social_studies ?></center></th>
350 <th><center><?php echo $science ?></center></th>
351 <th><center><?php echo $totalfinal ?></center></th>
352 <th><center>-</center></th>
353 <th><center>-</center></th>
354
355 <!--Displaying all the averages************************************************************************************-->
356 </tr>
357 <tr >
358 <td width="30">
359 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" >
360 </td>
361 <th><center>Average</th>
362 <th><center>-</th>
363 <th><center>-</th>
364 <th><center><?php echo $amaths ?></center></th>
365 <th><center><?php echo $aenglish ?></center></th>
366 <th><center><?php echo $akiswahili ?></center></th>
367 <th><center><?php echo $asocial_studies ?></center></th>
368 <th><center><?php echo $ascience ?></center></th>
369 <th><center>-</center></th>
370 <th><center><?php echo $classaverage ?></center></th>
371 <th><center><?php echo $classgrade ?></center></th>
372
373 </tr>
374 <tr style="background-color:#D79778;">
375
376 <td><center></center></td>
377 <td><center></center></td>
378 <td><center></center></td>
379 <td><center></center></td>
380 <td><center></center></td>
381 <td><center></center></td>
382 <td><center></center></td>
383 <td><center></center></td>
384 <td><center><b><i>General remarks<i></b></center></td>
385 <td><center></center></td>
386 <td><center></center></td>
387 <td><center><b><i><?php echo $totalpaid ; ?></i></b></center></td>
388 <td><center></center></td>
389 </tr>
390
391 </table>
392 </form>
393
394 </div>
395 <!--****************end of perfomance codes**********************-->
396 <!--****************put the displinary case codes here**********-->
397 <label>Displinary case</label>
398 <div style="height:auto; ">
399
400 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
401 <?php
402 $admission_number=$_GET['admission_number'];
403 $sql="SELECT SUM(amount) AS value_sum FROM fee WHERE
404 admission_number='$admission_number'";
405 $user_query=mysqli_query($db,$sql) or die("error getting data");
406 while($row = mysqli_fetch_array($user_query)){
407
408 $totalpaid= $row['value_sum'];
409 }
410 //$balance=$feepayable-$totalpaid;
411
412 ?>
413
414 <thead>
415 <tr>
416 <th></th>
417 <th><center>Dis. ID</center></th>
418 <th><center>Date</center></th>
419 <th><center>Case</center></th>
420
421
422 <script src="assets/js/jquery.dataTables.min.js"></script>
423 <script src="assets/js/DT_bootstrap.js"></script>
424 <th></th>
425 </tr>
426 </thead>
427 <tbody>
428 <?php
429
430 $id=$_GET['id'];
431
432 $sql ="SELECT * from displinary_case where admission_number='$admission_number'";
433 $user_query=mysqli_query($db,$sql) or die("error getting data");
434 while($row = mysqli_fetch_array($user_query)){
435 $admission_number = $row['admission_number'];
436 ?>
437
438
439 <tr>
440 <td width="30">
441 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $admission_number; ?>">
442 </td>
443 <td><center><?php echo $row['displine_id']; ?></center></td>
444 <td><center><?php echo $row['date_c']; ?></center></td>
445 <td><center><?php echo $row['displine_case']; ?></center></td>
446
447
448 </tr>
449
450 <?php } ?>
451 <tr style="background-color:#D79778;">
452
453 <td><center></center></td>
454 <td><center></center></td>
455 <td><center></center></td>
456
457 <td><center><b><i>General remarks<i></b></center></td>
458 <td><center><b><i><?php echo $totalpaid ; ?></i></b></center></td>
459 <td><center></center></td>
460 </tr>
461 </tbody>
462 </table>
463 </form>
464
465 </div>
466 <br>
467 <input type="submit" name="register" value="Print" class="btn btn-success">
468
469 </form>
470 <!--****************************************************************************-->
471
472 <?php
473 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
474 if (isset($_POST['register'])){
475
476
477 $admission_number=$_POST['admission_number'];
478 $date_c=$_POST['date_c'];
479 $displine_case=$_POST['displine_case'];
480
481
482 mysqli_query($conn,"INSERT INTO displinary_case(admission_number,date_c, displine_case)
483 VALUES ('$admission_number','$date_c','$displine_case')") or die(mysqli_error());
484
485
486 ?>
487 <?php
488 $query="SELECT * FROM displinary_case";
489 $records2=mysqli_query($db,$query);
490 while($rec=mysqli_fetch_array($records2))
491 {
492 $id = $rec['displine_id'];
493 }?>
494
495 <script>
496
497 alert('Succsessfully Save.');
498 window.location = "displine.php?id=<?php echo $id;?>";
499 </script>
500 <?php }?>
501 <!--*******************************try add parent's details******************************************************-->
502 </div>
503 </div>
504 </div>
505 <!-- /.container-fluid -->
506 </div>
507 <!-- /#page-wrapper -->
508 </div>
509
510 </div>
511 </div>
512 </div>
513 </div>
514 </div>
515
516
517
518 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
519 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
520 </div>
521 <script src="assets/js/jquery.min.js"></script>
522 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
523 <script src="assets/js/affix.js"></script>
524 <script src="assets/js/alert.js"></script>
525 <script src="assets/js/alert1.js"></script>
526 <script src="assets/js/bootstrap.js"></script>
527 <script src="assets/js/bootstrap.min.js"></script>
528 <script src="assets/js/bootstrap-datepicker.js"></script>
529 <script src="assets/js/bootstrap-wysihtml5.js"></script>
530 <script src="assets/js/button.js"></script>
531 <script src="assets/js/carousel.js"></script>
532 <script src="assets/js/chosen.jquery.min.js"></script>
533 <script src="assets/js/ckeditor.js"></script>
534 <script src="assets/js/collapse.js"></script>
535 <script src="assets/js/color.js"></script>
536 <script src="assets/js/dropdown.js"></script>
537 <script src="assets/js/DT_bootstrap.js"></script>
538 <script src="assets/js/dynamic.js"></script>
539 <script src="assets/js/ie-emulation-modes-warning.js"></script>
540 <script src="assets/js/jquery.dataTables.js"></script>
541 <script src="assets/js/jquery.dataTables.min.js"></script>
542 <script src="assets/js/jquery.dialog.js"></script>
543 <script src="assets/js/jquery.hoverdir.js"></script>
544 <script src="assets/js/jquery.jgrowl.js"></script>
545 <script src="assets/js/jquery.knob.js"></script>
546 <script src="assets/js/jquery.uniform.min.js"></script>
547 <script src="assets/js/jquery-1.8.3.min.js"></script>
548 <script src="assets/js/jquery-1.9.1.js"></script>
549 <script src="assets/js/jquery-1.9.1.min.js"></script>
550 <script src="assets/js/jquery-1.10.2.js"></script>
551 <script src="assets/js/jquery-1.11.0.js"></script>
552 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
553 <script src="assets/js/jquery-ui-1.10.3.js"></script>
554 <script src="assets/js/modal.js"></script>
555 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
556 <script src="assets/js/myjquery.js"></script>
557 <script src="assets/js/myjquery1.js"></script>
558 <script src="assets/js/npm.js"></script>
559 <script src="assets/js/popover.js"></script>
560 <script src="assets/js/profile.js"></script>
561 <script src="assets/js/raphael-min.js"></script>
562 <script src="assets/js/sb-admin-2.js"></script>
563 <script src="assets/js/scripts.js"></script>
564 <script src="assets/js/scrollspy.js"></script>
565 <script src="assets/js/tab.js"></script>
566 <script src="assets/js/tooltip.js"></script>
567 <script src="assets/js/transition.js"></script>
568 <script src="assets/js/wysihtml5-0.3.0.js"></script>
569 <script language="javascript" type="text/javascript">
570 $(window).load(function()
571 {
572 $('#loading').hide();
573 });
574 </script>
575 </body>
576
577 </html>
